package com.liliang.mapper;

import com.liliang.entity.Stock;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author liliang
 * @since 2021-11-04
 */
public interface StockMapper extends BaseMapper<Stock> {

    Integer findStockCountLike(@Param("stockName") String stockName, @Param("materialName")String materialName, @Param("stockType")String stockType,@Param("status") String status);


    List<Map> findStockPage(@Param("page")int page, @Param("max")Integer rows,@Param("stockName") String stockName,@Param("materialName") String materialName, @Param("stockType")String stockType, @Param("status")String status);

    List<Map> selectStockByStatus(@Param("a")int i, @Param("b")Integer rows);

    Integer selectStockByStatuscount();

    Integer selectStockByStatuscount2(@Param("a")String zt);

    List<Map> selectStockByStatus2(@Param("a")int i, @Param("b")Integer rows, @Param("c")String zt);
}
